no self-joins in views? - Mailing list pgsql-general

From Christoph Pingel
Subject no self-joins in views?
Date
Msg-id a06100501be313778a604@[62.224.60.178]
Whole thread Raw
Responses Re: no self-joins in views?
Re: no self-joins in views?
Re: no self-joins in views?
List pgsql-general
Hello,

is there any restriction re the use of self joins in views? I have a
moderately complicated query where I scan the same table twice using
aliases, and I would like to put that into a view to keep my python
code clean. However, I get an error 'column xy duplicated'. Is this
so by design?

best,
Christoph

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Python Interface
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Python Interface